when to use correlated subquery in Oracle

welcome to shbcf.ru